package com.binguo.model.mapper;

import com.binguo.model.core.Mapper;
import com.binguo.model.model.ShopQucanguiSmsConfig;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ShopQucanguiSmsConfigMapper extends Mapper<ShopQucanguiSmsConfig> {

    @Select("select id as id,shop_id as shopId,branch_id as branchId,interval_min as intervalMin ,remind_num as remindNum,latest_hour as latestHour,interval_shop_hour as intervalShopHour ,create_id as createId ,create_time as createTime,update_id as updateId,update_time as updateTime from shop_qucangui_sms_config where shop_qucangui_sms_config.shop_id in (select DISTINCT cashier_desk.shopId from cashier_desk inner join cashier_desk_extend on cashier_desk.id = cashier_desk_extend.desk_id where cashier_desk_extend.type = 10)")
    List<ShopQucanguiSmsConfig> getAllShopSetting();

}